Could you please attach mocked up sample data.
We anyways need data and preparing hand made data by answerer is very inefficient.
Follow the below steps:
1)Select All The column which you want
2)Right Click and Select "Pivot" option on data source level.
If above solution is working then marked as correct or helpful.
Amar D. Savale.
Also - The Pivot option for this table is not available; doesn't show up in the drop down.
Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread
1. M1. pos: size()/index()
2. D1. Search: [Mood 1]+[Mood 2]+[Mood 3]+[Mood 4]+[Mood 5]+[Mood 6]+[Mood 7]+[Mood 8]
3. D2. Ignor 0: if str(int(((findnth([D1. Search],'Like',1))/7)+1))='1' then ' ' else 'Mood'+str(int(((findnth([D1. Search],'Like',1))/7)+1)) end
4. Drag the required objects to the indicated locations
Hope it helps,
neutral_nalmai_v10.5.twbx 155.2 KB
Hi! Thanks for your help. I just have one issue (I attached a screen shot)
If I write the formula exactly as you have it, it says "Mood Combo" is an undefined field, so I renamed the Calculated Field column to "Mood Combo", but it now says there's a circular reference.
Also, do any of the numbers need to change in your formula since there are other columns in the table (not relating to Mood)?
Thank you. I really appreciate it.
Mood Combo is the concatenation of all the strings from Mood 1 to 8 into one single string. Sorry I should have mentioned that. So keep the formula as it is, just create another calculated field as shown below.
[Mood 1]+[Mood 2]+[Mood 3]+[Mood 4]+[Mood 5]+[Mood 6]+[Mood 7]+[Mood 8]
*If this helps, then please mark it Helpful and Correct to close this thread