How to transpose data

[Anonymous]

Hi,

I have currently got data in this format.

I need to be able to transpose the data into this format in order to make it usable. This will be live data flowing in so it needs to be able to automatically update when new data comes in.

Thanks

[MarcoWedel]

Hi,

one solution could be:

table1:
CrossTable (Title,BRAG,3)
LOAD * FROM [https://docs.google.com/spreadsheets/d/e/2PACX-1vQSt29RQzxgwTnYC30CHh0ThZZL7q0TbfJxjczTaUzaPfzJu-Wdd...] (html, codepage is 1252, embedded labels, table is @1, filters(Remove(Row, Pos(Top, 1)),Remove(Col, Pos(Top, 1))));

Join
LOAD Distinct
    Title,
    SubField(Title,';',1) as Letter,
    TextBetween(SubField(Title,';',2),'[',']') as Session
Resident table1;

Maybe also helpful:

Uploading a Sample

hope this helps

regards

Marco