SQL query rows transpose to columns

News UiPath Community Kudos
, ,
1

I have one SQL table transpose rows to columns,

This input:

IMG_20240823_233447653
IMG_20240823_2334476531920×863 238 KB

Expected output :

The image shows a spreadsheet with student information including SID, NAME, AGE, MENU, CLASS, STD, and SEC, where B2 contains "111", B3 contains "AAA", and B4 contains "12". (Captioned by AI)
The image shows a spreadsheet with student information including SID, NAME, AGE, MENU, CLASS, STD, and SEC, where B2 contains "111", B3 contains "AAA", and B4 contains "12". (Captioned by AI)1920×863 182 KB

I want each student id transpose, output file headers static for all.only we can update individual student details

2

@AJITH_SK

Use copy paste range and select transpose

Cheers

3

I paste to other excel
template file, not same file

4

@AJITH_SK

Copy paste would work to copy to a separate file as well

The image shows documentation for the UiPath activity "Copy/Paste Range," highlighting its capabilities to copy ranges/sheets within and between workbooks, or to the clipboard, and transpose data. (Captioned by AI)
The image shows documentation for the UiPath activity "Copy/Paste Range," highlighting its capabilities to copy ranges/sheets within and between workbooks, or to the clipboard, and transpose data. (Captioned by AI)828×708 108 KB

Cheers