Transpose tool related support

Question

Hello I have data which has different data in column and i want to transpose and getting data in raw but this data is comming in  in three rcolumn  And i want it in single  raw with corrosponding value .

Attached is example -

I want this data to come in single column rather 3 . Please support me. Thanks AK

indakath · Answer

Thanks for your response, appreciate it, but I want Name Status should remain in column and value should come in raw along with header, because I want name to be used as filter and rest details should come accordingly .

as example

Name Expiry Date Agency Status Halal Status 1/1/2022AYKosher Status 2/2/2023BNGMO status 3/2/2023cN

Whereas in your solution i wont be abe to use name for filter .. its complete transpose ...

Thanks

binu_acs · Answer

@indakath are you looking for something like this?

Transpose_270323.yxmd