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:
A,B
Label1,ID_Name
Label2,email address
Label3,Data
Label3,Data
Label4,Data
Label4,Data
Label1,ID_Name
Label2,email address
Label3,Data
Label4,Data
Label4,Data
Label4,Data
Label4,Data
looking for something like this so label3 one cell per record and label4 same something in between each like CSV example below
Label1,Label2,Label3,Label4
Value,Value,Label3value1;Label3value2,Label4value1;Label4value2
Value,Value,Label3value1,Label4value1;Label4value2;Label4value3
Value,Value,Label3value1;Label3value2;Label3value3,Label4value1
Bookmarks