So I can see where I want the data to go, and I feel like I got started in the right direction, but I cannot get my transform to name those index values ([‘Facility’, ‘SectionName’, ‘Etc’] instead of [0,1,2])
Can you please explain to me what I am doing wrong in my transform to get names on each of those column index values. I am essentially getting what I want, but without names, I cannot apply column formatting, making my table much less usable.
Line 86 of your posted script looks like: newData.append([facility, sectionName])
That means you’re appending a new list to the data - so you’ll end up with a structure like: