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 :
Thanks
DILIP BK
Hi @DilipChiru 
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? 
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 
Hi @DilipChiru 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 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?
Hey sorry to high jack this thread.
Try this also, i think it works
Try this now
