Importing PDF Nightmare

[hockeycoach]

Hey All,

I've been racking my brain trying to import a PDF and make it look the same once loaded into Excel365. No matter what I try, I end up with all of my column data, in one row, as opposed to individual rows. I can't split the column because the data in it is random sizes and no discernable and consistent characters/numbers etc. To compound the issue, if I attempt to resize any of the columns, the text/data that's in the column, no longer matches it's adjacent match.

Man-alive, I sure could use a wee bit of help...

**How it SHOULD look

MrExcel_UpLoad.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	ITEM 6682366 2237677 3933762 6297983 9626333 9626336 8667333 2276332 2266333 6683227 7728826 6286662 6286662 6233676 3636323 6667336 6626766 6663986 6622929 6627933 6627933 7789362 2386336 6229773 6626723 6989332 6663263 2722632 2722632 6989332 2266333 3267233 2266336 6833636 6833633 2733373 6793283 2662633 2733376 2.666663 2237333 2733376 7776372 6777379 6269767 627899 6676332 7227 877 6398232 6776326 6299787 6723338 6333683 727333 727333 727333 9972772 6227782 6633293 6723637 836969 6726923 8982376 6779773 6778866 2733373 2722632 2722633			DESCRIPTION KNARLY BOYS SHORTS WOODY 2PK BOYS TEE SUNICE GOLF SHORT 37 LUCKY MEN'S SS GRAPH SIERRA DESIGN CAPRI SIERRA DESIGN CAPRI SIERRA DESIGNS TECH EGGIES LINEN SHORT L 32D TWILL SOCKS XS E.BAUER ACTIVE EGOS JOYBEES KIDS CLOG KEDS CANVAS SHOE 66 KEDS CANVAS SHOE 66 GLOBE WIFI SMART PLU SUNICE LINED SOCKS XL GAP CHINO SOCKS 32 PARSUCO MAT HODIE S BITES KIDS 7 PIECE SE PARASUCO MAT DNM SB BAN REP 2PKT SOCKS 36 BAN REP 2PKT SOCKS 36 BENCH COMFORT SLIDE EGGIES LINEN DRESS M CARTERS 3 PIECE SET PARSUCO .AT HODIE S CH 7PC PJ SET L TUFFY GIRLS SLEEPER 32D SKORT L 32D SKORT L CH 7PC PJ SET L 32D TWILL SOCKS XS WPV 3QTR SLV TEE 2PK 32D TWILL SOCKSS HILARY RADLEY CAPRI HILARY RADLEY CAPRI PACIFIC TRAIL SHORT BC TECH SOCKS 33 BANANA REPUBLIC TEE PACIFIC TRAIL SHORT WOODY SS TSHIRT XL BERNIES LEGGING XS PACIFIC TRAIL SHORT KS MENS LIGHTWEIGHT SUPERGRIP CHAIRMAT 3 BERNIES T-SHIRT SPEEDO GIRLS SWIMSUI BUFFALO SS TSHIRT L FINISH ULTIMATE QUAN KS ORGANIC SEAWEED SCOTTIES PREMIUM 2 P BITES BIKINI 7PK XL BITES MENS RUNNER 8 LINKFAIR SS 62.2" WO FROSTED FLAKES 6.76K FROSTED FLAKES 6.76K FROSTED FLAKES 6.76K COUTURE BLACKOUT CUR SWIFFER STARTER KIT FEIT STRING LIGHTS 7 BUDWEISER O. 3%- RED BULL ENRGY DRINK KETER GRANDE 662G DE DYNATRAP l ACRE BUTANE STOVE BUFFALO GRL BRIEF 9P PACIFIC TRAIL SHORT 32D SKORT L 32D SKORT S				ITEM QTY 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 5 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 2.33 6. 33 6. 33 3 6. 33 3 3 3 3 3 3 3		SELL PRICE 67.99 66.99 69.99 63.99 68.99 68.99 69.99 63.99 62.99 68.99 26.99 32.99 32.99 69.99 22.99 29.99 29.99 27.99 29.99 26.99 26.99 68.99 23.99 66.99 29.99 26.99 8.99 66.99 66.99 26.99 62.99 68.99 62.99 66.99 66.99 26.99 27.99 67.99 26.99 63.99 27.99 26.99 29.99 77.99 68.99 63.99 62.99 23.99 62.99 22.99 · 68.99 77.99 77.99 9.79 9.79 9.79 39.99 67.99 79.99 27.79 76.79 699.99 699.99 69.99 62.99 26.99 66.99 66.99		EXT. SELL PRICE 67.99 66.99 69.99 63. 99 68.99 68.99 69.99 63.99 62.99 68.99 26.99 32.99 32.99 69.99 22.99 29.99 29.99 27.99 29.99 26.99 26.99 68.99 23.99 66.99 29.99 26.99 8.99 66.99 66.99 26.99 62.99 68.99 62.99 66.99 66.99 26.99 27.99 67.99 26.99 63. 99 27.99 26.99 29.99 77.99 68.99 63. 99 62.99 23.99 62.99 22.99 68.99 77.99 77.99 9.79 9.79 9.79 79.98 67.99 79.99 27.79 76.79 699.99 699.99 69.99 62.99 26.99 66.99 66.99			SALVAGE%- 23 23 23 23 23 23 23 23 23 23 23 23 23 32 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 32 23 23 23 32 32 32 23 23 32 32 32 32 32 32 32 32 32 32 32 32 23 23 23 23		SALVAGE AMOUNT 3.63 3.73 7.33 2.83 3.83 3.83 7.33 2.83 3.23 3.83 7.73 7. 2 3 7.23 7.33 7.63 3 3 2.33 3 2.73 2.73 3.83 7.83 3.73 3 2.73 6.83 3.73 3.73 2.73 3.23 3.83 3.23 3.73 3.73 2.73 2.33 3.63 2.73 2.83 2.33 2.73 3 62.72 3.83 2.83 2.63 8.73 7.22 9.63 3.83 9.33 26.22 3.73 3.73 3.73 27.99 2.22 67.23 8.68 67.22 73.33 73.33 7.33 3 .23 2.73 3. 73 3.73
2
Table 1

 

[Akuini]

@hockeycoach
Indeed, converting PDF content to Excel could be complicated. If the PDF isn't sensitive material, could you please upload a sample file (without sensitive data) to a file-sharing site like Dropbox.com or Google Drive and then share the link here? Also, ensure that the link is accessible to anyone.