I have a database which has about 60000 rows and 3 columns.
Here I have made a picture to show what exactly I want, this picture represent a general view of my data structure and also represent what I want.
I have 3 first columns (from left) and I want to create a new column like the last one which named New Text.
As you see I want to create a column which duplicate the Text of every row for X times. And X is the frequency of repeated number in Number ID 2.
For example: In Number ID 2, 8 repeated four times. So New Text should have four H. (H represent the text)
Please consider this to be done by Microsoft Access software, which I have no experience of working with.
Here I have made a picture to show what exactly I want, this picture represent a general view of my data structure and also represent what I want.
I have 3 first columns (from left) and I want to create a new column like the last one which named New Text.
As you see I want to create a column which duplicate the Text of every row for X times. And X is the frequency of repeated number in Number ID 2.
For example: In Number ID 2, 8 repeated four times. So New Text should have four H. (H represent the text)
Please consider this to be done by Microsoft Access software, which I have no experience of working with.