Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Copy Paste Data without Totals and Blanks in rows

Avatar

Avatar
Boost 5
Level 2
carol_pons
Level 2

Likes

5 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
carol_pons
Level 2

Likes

5 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
carol_pons
Level 2

05-05-2015

It would save users a significant amount of time if Total and Blank rows did not show when you copy data our of a an Ad Hoc Analysis ranked report.  This data is likely dropped into excel and in order to pivot the data, these rows must be removed.  Can you please remove the rows that are totals and blanks?

1 Comment

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

05-05-2015

Good suggestion, @CarolPons. I think we'll probably first try to solve this in the Analysis Workspace on the web, which you might have seen. We'll also monitor this for votes as it pertains to Ad Hoc Analysis.