Creating tables from total rows

Resolved · Urgent Priority · Version 365

Tue 5 Dec 2023, 14:34 Delegate Rose said...

Rose has attended:
Excel Intermediate course
Excel Advanced course

Creating tables from total rows

Hi there,

Is there anyway to create a pivot table from the total rows of other tables please?

I have 4 tables for each year, each with a total row and want to create a new table from the results of the total row split by each year.

Many thanks,
Rose

Fri 8 Dec 2023, 13:51 Trainer Martin said...

RE: Creating tables from total rows

Hi Rose,

Thank you for your question to the forum

It may help to send me a sample of the data you are trying to manipulate. Please email:

info@stl-training.co.uk

Kind regards
Martin Sutherland
(IT Trainer)

Fri 12 Jan 2024, 00:43 Trainer Rich said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips