Forum home » Delegate support and help forum » Microsoft Excel Training and help » Creating tables from total rows

Creating tables from total rows

ResolvedVersion 365

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

Rose has attended:
Excel Intermediate 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.

Thu 18 Jan 2024: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips

Creating tables from total rows

Creating tables from total rows

RE: Creating tables from total rows

Will be marked as resolved in 5 days

Excel articles

Excel tip:

##### displaying in Excel