Compare row with column in Excel

Help Studio
, ,
1

Hi All,
Can you tell me how to compare a different form of table?

The first table is written vertically

This image shows an open Microsoft Excel sheet containing address information for an individual, including fields for street, city, region, and country, along with a row indicating an attachment file. (Captioned by AI)
This image shows an open Microsoft Excel sheet containing address information for an individual, including fields for street, city, region, and country, along with a row indicating an attachment file. (Captioned by AI)1920×1080 218 KB

And the second table is written horizontally

An Excel spreadsheet displays personal identification information including NIK, birthdate, place of birth, marital status, nationality, occupation, address, and validity, with varying cell colors for some entries. (Captioned by AI)
An Excel spreadsheet displays personal identification information including NIK, birthdate, place of birth, marital status, nationality, occupation, address, and validity, with varying cell colors for some entries. (Captioned by AI)1920×1080 212 KB

Thanks
ExtractionResults11072024.xlsx (6.5 KB)
SFRequestData11072024.xlsx (6.4 KB)

2

@Nafissa_Al_Abida,

Follow this thread to transpose first excel to match with the second

Once done then do comparison by reading both the files into datatable then comparing column to column.

3

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