I have some data in a spreadsheet structured like this. How do I get t...

I have some data in a spreadsheet structured like this. How do I get the data on the two rows below the account name that is in bold on the same row? Any tips or tricks? There’s too many rows to do manually.

7 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hey Ari, thanks for reaching out! QQ, do all rows have the same 2 empty lines below, like is this the pattern for all?If so, I'd probably just select all cells in that column and drag the account name down. The only thing missing would be the other floating rows... maybe someone has a better idea and can share some tips lol
Ari G.
·
·
Yes it does follow the same pattern
Ari G.
·
·
the only problem is theres like 3k rows
Ari G.
·
·
so any automated way of solving this problem would help 🙂
Clay Team
APP
·
·
ahhh! Sorry for the delay! Not exactly an excel or google sheets expert but will do some digging
Ari G.
·
·
No worries figured it out. Thanks!