Convert multiple x rows for a record to single - vertical to horizontal data
Hello, thought I would post to see if anyone can help. I have a rather large set of data but the format is far from the way a easily understandable format. current the labels are listed in Rows in column A and the data is in B. so the transpose option didn't work.
The number of data for label3 and 4 can change but each record has a Label1 and Label2. LAbel 2 is normally an email but not all the data is clean.
In Excel the data Excel the data is arranged like this:
looking for something like this so label3 one cell per record and label4 same something in between each like CSV example below
Last edited by DinLA; 04-22-2011 at 12:00 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1