Grouping data from 1st sheet and rewrite the data under smallheader

Help StudioX
,
1

hi guys, I have a raw data which is unsort. i want to rewrite the data by grouping column C into a new data like below. Any advise? FYI, Im using studioX as a citizen developer.

Raw Data

A spreadsheet displays transactions in USD, listing amounts and the respective suppliers from which purchases were made. (Captioned by AI)
A spreadsheet displays transactions in USD, listing amounts and the respective suppliers from which purchases were made. (Captioned by AI)361×379 6.11 KB

Final Data that I intend it to be

This image shows a spreadsheet listing purchases from suppliers A, B, C, and D, including respective amounts and currencies. (Captioned by AI)
This image shows a spreadsheet listing purchases from suppliers A, B, C, and D, including respective amounts and currencies. (Captioned by AI)371×517 8.81 KB

2

you can try below logic:

(In activities pane>click on Developer option to use Invoke Code activity)

image
image921×761 30.1 KB

Invoke code will be:

dt_Output.Rows.Add({currentItem(0)(2).ToString}) 'Supplier Name Row

For Each rw As DataRow In currentItem
	dt_Output.Rows.Add(rw.ItemArray)
Next rw

dt_Output.Rows.Add({}) 'Blank row

let us know if it works for you or if you need more help

3

This image shows the Activities panel in UiPath Studio, displaying various categories of activities such as Favorites, Recent, Installed, and Classic. (Captioned by AI)
This image shows the Activities panel in UiPath Studio, displaying various categories of activities such as Favorites, Recent, Installed, and Classic. (Captioned by AI)374×728 14 KB

can i know where is the developer option

4

click on filter button and then click on Developer