Hello,

I have a sheet that is roughly 10,000 rows long. In columns A-F I have
data. In columns G, H, and I, I have summary counts of that data in 3
categories. The summary data in G, H, and I is separated by about 200-300
rows at a time. Is there any way to cut out those columns, put them into a
new sheet, and then eliminate the 100's of rows in between, so that I'm left
with just the data in consecutive rows?

As always, thanks!

Nevermind, I just discovered the data filter tool!

"pm" wrote:

Hello,

I have a sheet that is roughly 10,000 rows long. In columns A-F I have
data. In columns G, H, and I, I have summary counts of that data in 3
categories. The summary data in G, H, and I is separated by about 200-300
rows at a time. Is there any way to cut out those columns, put them into a
new sheet, and then eliminate the 100's of rows in between, so that I'm left
with just the data in consecutive rows?

As always, thanks!