From excel table row to printable id card

[benlandgren]

Hi,
I have excel table with many columns that contain information about orders. Each row is an order ID. I would like to create a sheet (ID card) that presents the data of one order ID in a very clear and printable layout. I tried using pivot tables as there is a neat filter field where you can insert the ID in question to get the details but somehow I cannot finad a way to affect too much on the layout and it stays in the same wide format as in the table.

I know that I can do this with match and index functions but as there is alot of information that can still change at some point, I would prefer not to use them. I have attached a draft of possible layout.

Does anybody have an idea how to do this? Is this possible in pivot tables or power apps and how?

I am using office 365.

Thank you in advance.plm.png

[macropod]

You might try a mailmerge using Word to connect to your workbook as the datasource.

[benlandgren]

Hi,

Thank you very much. However I forgot to mention that the idea of the excel workbook is to reduce the huge amount of current workbooks and files, therefore I am looking for a solution that can be done inside excel.