I have a excel sheet as
A 1 2 3 4 B 1 2 C 1 2 3 4 5
I need the output to be looked as
A 1 A 2 A 3 A 4 B 1 B 2 C 1 C 2 C 3 C 4 C 5
I will be greatful if anyone will help in finding a solution for this
You'll need to achieve this with VBA code.
Assuming you input sheet is called "input" and your output sheet is called "output" and that the input starts a cell A1 without headers, the following code will work:
What this does is it loops through every row if your input data starting at A1 down to the last cell in A that has data.
Then in each row, it loops through every column that is populated.
For each of these columns of data in your input sheet it is copying the values of that pair to the output sheet.