I have 2 columns of data in an excel sheet. I would like all of column A to be be transposed to row 1, e.g. Name, Address, Transaction date, etc... I would like all of the corresponding information in column B to fall under those values where they belong.
I know how to transpose in Excel, but the problem is there are multiple values in column A which are redundant. I need redundant data to fall into a single column. Also, it is randomly placed information (it doesn't follow a certain sequence).
I am attaching the document I need manipulated for view.
If anyone can help me, I would appreciate it.
Bookmarks