Merging tables from multiple pdfs into Excel - not separating

I'm lifting data collected on standardized pdf forms onto an Excel worksheet. Using the 'from FILE' option with mulitple pdfs (exact same table format).
My problem...rather than landing on separate rows...the data from each pdf transfers in squence on the same row.
Why is this and how do I fix this?
I'm using Excel 2021.
THANKS! MHKG

Administrative Note:

Is your forum profile showing the version of Excel that you need this to work for?

Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

Also: Please read the banner at the top of this page in yellow.

Have you tried putting all the pdf files in one folder and using Get From Folder and then Transform. Are you attempting to append them to each other. Your explanation is a little bit vague in your expectations. Did you read the yellow banner at the top of this page as noted in my post?

Cannot offer any further help unless you post some samples as requested so we can help to solve with a real issue and not guess at your needs. Help us to help you.