Convert column to row

Hi Team,

Need help in converting the values which are coming from “item list”. Please help me to print or display the below values to row from column.

[
{
“Location”: “Pune”,
“project_name”: “LNC”,
“count”: 22
},
{
“Location”: “Pune”,
“project_name”: “VIDC”,
“count”: 7
},
{
“Location”: “Pune”,
“project_name”: “abc”,
“count”: 12
},
]

From the above table can you please help me to print the JSON in the below format :

image

Thanks
DILIP BK

Hi @DilipChiru :wave: I’m not so sure I’m following - are you looking to have the JSON that you’ve provided sent over to a spreadsheet? Are you using Google Sheets, Excel, or just the Spreadsheet node? :+1:

Hi @EmeraldHerald ,

I am using just the spreadsheet below is the complete screenshot related to it.

Currently, I am send the complete list of data into an email using spreadsheet. Now I want to send send separate spreadsheet with the above data related to project and location count as mentioned below

This data is in the "Item list node of Location "
[
{
“Location”: “Pune”,
“project_name”: “LNC”,
“count”: 22
},
{
“Location”: “Pune”,
“project_name”: “VIDC”,
“count”: 7
},
{
“Location”: “Pune”,
“project_name”: “abc”,
“count”: 12
},
]

I would like to print the data into rows for “project_name” and Location as columns :slight_smile:

image

Hi @DilipChiru :wave: This might need some tweaking with other locations, but here’s an example that does what you’re looking for:

Hope that helps!

Hi @EmeraldHerald ,

Thank you so much, this what I was looking for it.
May I know how can we add the total column as at the last .

Thanks
DILIP BK

Hi @DilipChiru :wave: No problem!

Just to make sure I’m on the same page as you, are you wanting the “counts” to sum up to a total in another column?

Hi @EmeraldHerald ,

Yes, need the sum up to a total in another column?

Thanks

Hey sorry to high jack this thread.

Try this also, i think it works

1 Like

Hi @Mulen ,

I have tried using this and to move the column to last, but it is not working

Thanks

Try this now

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.