Data formatting Question

[Kibitokai]

Hi all!

I am using a data scraper to pull info from the web and an struggling to transform it in a way that's easily read.

Right now the csv file comes out like this:

Title - data
Title - data
Title - data

And then it repeats in blocks like that. What I want is to move the titles into the columns and then have the right side with all the data moved into the corresponding columns with the appropriate titles like

Title1 title2 title3
Data1 data2 data3

 

[awoohaw]

Okay, try this:

Mr excel questions 39.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Word Mark	ESKIMO EXTRACTS		Word Mark	Goods and Services	Standard Characters Claimed	Mark Drawing Code	Serial Number	Filing Date	Current Basis	Original Filing Basis	Owner	Type of Mark	Register	Live/Dead Indicator	Design Search Code	Attorney of Record	Description of Mark	Published for Opposition	Assignment Recorded	International Registration Number
2	Goods and Services	IC 037. US 100 103 106. G & S: Oil extraction services		ESKIMO EXTRACTS	IC 037. US 100 103 106. G & S: Oil extraction services	0	(4) STANDARD CHARACTER MARK	97771718	44954	1B	1B	(APPLICANT) Lee, Justin D LIMITED LIABILITY COMPANY SOUTH CAROLINA 2874 Stonestown Drive Charleston SOUTH CAROLINA 29414	SERVICE MARK	PRINCIPAL	LIVE	26.03.02 - Ovals, plain single line ; Plain single line ovals	Scott M. Sisun, Esq.	The color(s) blue, red, and white is/are claimed as a feature of the mark. The mark consists of the word ESKIMO appearing in red within a blue oval.	44838	ASSIGNMENT RECORDED	1727184
3	Standard Characters Claimed			ESKIMO	IC 029. US 046. G & S: milk, yoghurt and other derived products from milk IC 030. US 046. G & S: ice cream, sorbets, ice pops IC 032. US 045 046 048. G & S: natural juices of all kinds and flavors, non-alcoholic beverages, fruit juices, fruit juice	0	(3) DESIGN PLUS WORDS, LETTERS, AND/OR NUMBERS	97748078	44936	1B	1B	(APPLICANT) Comercializadora De Lacteos Y Derivados, S.A. De C.V. Sociedad Anónima de Capital Variable MEXICO Calz. Carlos Herrera Araluce Num Ext 185 Parque Indust. Carlos A Herrera Araluce Gomez Palacio, Durango MEXICO 35079	TRADEMARK	PRINCIPAL	LIVE		Neil A. Burstein		44838	ASSIGNMENT RECORDED
4	Mark Drawing Code	(4) STANDARD CHARACTER MARK		ESKIMO	IC 042. US 100 101. G & S: Software design and development. FIRST USE: 20181029. FIRST USE IN COMMERCE: 20190812	0	(4) STANDARD CHARACTER MARK	97671767	44875	1A	1A	(APPLICANT) ESKIMO SOFTWARE LIMITED LIABILITY COMPANY NEW JERSEY 2 MAIN ST #1402 SPARTA NEW JERSEY 07871	SERVICE MARK	PRINCIPAL	LIVE				44936
5	Serial Number	97771718		ESKIMO PIE	IC 025. US 022 039. G & S: Graphic T-shirts	0	(4) STANDARD CHARACTER MARK	90013691	44004	1B	1B	(APPLICANT) RETROBRANDS AMERICA LLC LIMITED LIABILITY COMPANY FLORIDA POB 11106 Fort Lauderdale FLORIDA 33339	TRADEMARK	PRINCIPAL	LIVE
6	Filing Date	44954		ESKIMO PIE	IC 030. US 046. G & S: Ice cream	0	(4) STANDARD CHARACTER MARK	90012653	44003	1B	1B	(APPLICANT) RETROBRANDS AMERICA LLC LIMITED LIABILITY COMPANY FLORIDA POB 11106 Fort Lauderdale FLORIDA 33339	TRADEMARK	PRINCIPAL	LIVE
7	Current Basis	1B		ESKIMO BROTHERS	IC 025. US 022 039. G & S: Clothing, namely, shirts, sweat shirts, socks, ties, baseball caps		(4) STANDARD CHARACTER MARK	90692081	44321	1B	1B	(APPLICANT) Ian J. Woods INDIVIDUAL UNITED STATES 545 48th Avenue N. St. Petersburg FLORIDA 33703	TRADEMARK	PRINCIPAL	LIVE
8	Original Filing Basis	1B
9	Owner	(APPLICANT) Lee, Justin D LIMITED LIABILITY COMPANY SOUTH CAROLINA 2874 Stonestown Drive Charleston SOUTH CAROLINA 29414
10	Type of Mark	SERVICE MARK
11	Register	PRINCIPAL
12	Live/Dead Indicator	LIVE
13	Word Mark	ESKIMO
14	Goods and Services	IC 029. US 046. G & S: milk, yoghurt and other derived products from milk IC 030. US 046. G & S: ice cream, sorbets, ice pops IC 032. US 045 046 048. G & S: natural juices of all kinds and flavors, non-alcoholic beverages, fruit juices, fruit juice
15	Mark Drawing Code	(3) DESIGN PLUS WORDS, LETTERS, AND/OR NUMBERS
16	Design Search Code	26.03.02 - Ovals, plain single line ; Plain single line ovals
17	Serial Number	97748078
18	Filing Date	44936
19	Current Basis	1B
20	Original Filing Basis	1B
21	Owner	(APPLICANT) Comercializadora De Lacteos Y Derivados, S.A. De C.V. Sociedad Anónima de Capital Variable MEXICO Calz. Carlos Herrera Araluce Num Ext 185 Parque Indust. Carlos A Herrera Araluce Gomez Palacio, Durango MEXICO 35079
22	Attorney of Record	Scott M. Sisun, Esq.
23	Description of Mark	The color(s) blue, red, and white is/are claimed as a feature of the mark. The mark consists of the word ESKIMO appearing in red within a blue oval.
24	Type of Mark	TRADEMARK
25	Register	PRINCIPAL
26	Live/Dead Indicator	LIVE
27	Word Mark	ESKIMO
28	Goods and Services	IC 042. US 100 101. G & S: Software design and development. FIRST USE: 20181029. FIRST USE IN COMMERCE: 20190812
29	Standard Characters Claimed
30	Mark Drawing Code	(4) STANDARD CHARACTER MARK
31	Serial Number	97671767
32	Filing Date	44875
33	Current Basis	1A
34	Original Filing Basis	1A
35	Owner	(APPLICANT) ESKIMO SOFTWARE LIMITED LIABILITY COMPANY NEW JERSEY 2 MAIN ST #1402 SPARTA NEW JERSEY 07871
36	Type of Mark	SERVICE MARK
37	Register	PRINCIPAL
38	Live/Dead Indicator	LIVE
39	Word Mark	ESKIMO PIE
40	Goods and Services	IC 025. US 022 039. G & S: Graphic T-shirts
41	Standard Characters Claimed
42	Mark Drawing Code	(4) STANDARD CHARACTER MARK
43	Serial Number	90013691
44	Filing Date	44004
45	Current Basis	1B
46	Original Filing Basis	1B
47	Published for Opposition	44838
48	Owner	(APPLICANT) RETROBRANDS AMERICA LLC LIMITED LIABILITY COMPANY FLORIDA POB 11106 Fort Lauderdale FLORIDA 33339
49	Assignment Recorded	ASSIGNMENT RECORDED
50	Type of Mark	TRADEMARK
51	Register	PRINCIPAL
52	Live/Dead Indicator	LIVE
53	Word Mark	ESKIMO PIE
54	Goods and Services	IC 030. US 046. G & S: Ice cream
55	Standard Characters Claimed
56	Mark Drawing Code	(4) STANDARD CHARACTER MARK
57	Serial Number	90012653
58	Filing Date	44003
59	Current Basis	1B
60	Original Filing Basis	1B
61	Published for Opposition	44838
62	International Registration Number	1727184
63	Owner	(APPLICANT) RETROBRANDS AMERICA LLC LIMITED LIABILITY COMPANY FLORIDA POB 11106 Fort Lauderdale FLORIDA 33339
64	Assignment Recorded	ASSIGNMENT RECORDED
65	Type of Mark	TRADEMARK
66	Register	PRINCIPAL
67	Live/Dead Indicator	LIVE
68	Word Mark	ESKIMO BROTHERS
69	Goods and Services	IC 025. US 022 039. G & S: Clothing, namely, shirts, sweat shirts, socks, ties, baseball caps
70	Standard Characters Claimed
71	Mark Drawing Code	(4) STANDARD CHARACTER MARK
72	Serial Number	90692081
73	Filing Date	44321
74	Current Basis	1B
75	Original Filing Basis	1B
76	Published for Opposition	44936
77	Owner	(APPLICANT) Ian J. Woods INDIVIDUAL UNITED STATES 545 48th Avenue N. St. Petersburg FLORIDA 33703
78	Attorney of Record	Neil A. Burstein
kibito;akai

Cell Formulas
Range	Formula
D1:U1	D1	=TRANSPOSE(UNIQUE(A1:A81))
T2:T3,S2:S4,Q2:Q3,P2,R2,U2,G2:O7,F2:F6,D2:E7	D2	=INDEX(CHOOSECOLS(FILTER($A$1:$B$81,$A$1:$A$81=D$1),2),SEQUENCE(COUNTIF($A$1:$A$81,D$1)))
Dynamic array formulas.