Howdy. Newbie here and trying to find a way to flip the data from one column with many rows to 2 columns with multiple rows which satisfy the following criteria:
let say my 1 column has the following data. There is a blank row after every 2 rows but I can eliminate the blank rows, if necessary to make it easier to get the issue resolved:
A
A1
B
B1
C
C1
What I am looking to accomplish is Change 1 column of data to 2 columns, with data from the 2 adjacent rows (A & A1 or B& B1, etc.) split in 2 different columns but on same row.
A A1
B B1
C C1
Any assistance would be greatly appreciated.
Thanks.
Mark
Bookmarks