You change according to your Data structure. NB: The Data I've used to TEST the code has 3 Column(RED Colour Value), so that with For Loop Step & Resize value is 3. TikTok video from Mike Tholfsen - Microsoft tips (mtholfsen): 'Import PDF data into Excel excelpro learnexcel. XOutRg.Offset(xNRow, 0).PasteSpecial Paste:=xlPasteAll, Transpose:=True Set xOutRg = Application.InputBox('Select output range(specify one cell):', 'Transpose to Excel', xTxt,, ,, , 8) MsgBox 'Used range only contain one column',, 'Transpose to Excel' Set xRg = Application.InputBox('Select Data Range(only one column):', 'Transpose to Excel', xTxt,, ,, , 8) You can customize data to your liking by using the features given, like adding rows and columns, removing rows & columns, managing parameters, etc.I would like to suggest you VBA Code, this will Transpose the Copied Data Table from PDF to Excel.

Follow steps 1 – 5 from the first section.

You can further customize the data using the Power Query window. Select whichever options are relevant to you. You can even choose to load the data into a new worksheet rather than the existing sheet.

You will get options of Pivot Table Report, Pivot Table, etc.

Instead of clicking on Load, click on the arrow next to Load and select Load To.

Follow steps 1 – 5 from the above section.

You can adjust the Load settings if you want to get the data in some other form, like a pivot table. Your data will be imported into the Excel sheet in a table, but you can make further adjustments if you want to make the data seem more relevant to you. If it is something that you wish to convert to a spreadsheet form, click on it and then select Load. As per the issue description mentioned above, you want to extract specific data from PDF file to Excel, is that correct Try opening the pdf file in Acrobat > right-click > choose Select Tool Select the data you want to extract > export selection as > choose. Click on any of the items, and you will get a preview on the preview screen.

Step-6: You will now get a Navigator Panel, and you will see a list of everything included in the PDF file. Step-5: Locate the File you wish to get data from.

Copy data from pdf to excel