Google Sheet converting a Column to a Row

Hi @MutedJam

Yes, the City | City 1 is the very first row in my input sheet; and the existing dataset has more than 3 rows, but each set will have the same rows consistently.

I have found this link in the community Convert column to row, but I am not sure if this is the solution for my case. I don’t think the Google Sheet node has a feature to convert columns to rows, but I am thinking of making a loop that converts a column dataset to a row dataset first, then deletes the whole column dataset for a new one coming up for a new conversion. That’s what I am thinking.

Thanks.