SOLVED
Home

Create a Table using lines as separators and not columns

%3CLINGO-SUB%20id%3D%22lingo-sub-810974%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810974%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394580%22%20target%3D%22_blank%22%3E%40DonutsSauvage%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20enter%20Line1%2C%20drag%20it%20to%20the%20right%20till%20LineN%20and%20Ctrl%2BT%20on%20selection%20with%20check%20first%20row%20as%20header%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810979%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810979%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20keeps%20on%20creating%20a%20Table%20using%20columns%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811013%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811013%22%20slang%3D%22en-US%22%3EI%20clarified%20the%20question%20because%20I%20think%20there%20was%20a%20misunderstanding%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-810950%22%20slang%3D%22en-US%22%3ECreate%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-810950%22%20slang%3D%22en-US%22%3E%3CP%3EPretty%20simple%20question%20but%20I%20didn't%20find%20any%20answer%20to%20this%3A%3C%2FP%3E%3CP%3EMy%20goal%20is%20Simply%20to%20create%20a%20Table%20in%20Excel%20like%20anyone%20would%20do%20using%20the%20%22create%20table%22%20option%2C%20but%20instead%20of%20having%20%22Column1%22%2C%20%22Column2%22...%20as%20fields%20for%20the%20table%2C%20I%20want%20to%20have%20%22Line1%22%2C%20%22Line2%22...%3CBR%20%2F%3EI%20already%20tried%20copy-pasting%20a%20table%20with%20the%20transpose%20option%20but%20Excel%20does%20not%20consider%20the%20result%20to%20be%20a%20table%20anymore.%20I%20work%20under%20Excel%20365.%3CBR%20%2F%3EEdit%3A%20To%20clarify%2C%20the%20goal%20is%20not%20to%20name%20the%20headers!%20I%20want%20to%20have%20a%20Table%20using%20ROWS%20as%20separators%20instead%20of%20COLUMNS.%3CBR%20%2F%3Ee.g%3A%3CBR%20%2F%3EHeader1%20%7C%20Value%201%20%7C%20Value2...%3CBR%20%2F%3E%3CSPAN%3EHeader2%20%7C%20Value%201%20%7C%20Value2...%3CBR%20%2F%3E%3CSPAN%3EHeader3%20%7C%20Value%201%20%7C%20Value2...%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-810950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811029%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811029%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394580%22%20target%3D%22_blank%22%3E%40DonutsSauvage%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20didn't%20catch.%20You%20have%20some%20range%20and%20would%20like%20to%20use%20values%20from%20first%20column%20as%20column%20names%2C%20or%20you'd%20like%20to%20rotate%20entire%20range%20to%20the%20right%20on%2090%2C%20or%20what.%20Perhaps%20you%20may%20give%20small%20sample%20how%20it%20shall%20be%20transferred.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811033%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811033%22%20slang%3D%22en-US%22%3EI'll%20try%20to%20be%20as%20precise%20as%20possible.%20The%20goal%20is%20to%20have%20a%20Table%20in%20Excel%2C%20for%20which%20the%20headers%20and%20corresponding%20values%20would%20not%20be%20in%20the%20same%20column%2C%20but%20the%20same%20row.%3CBR%20%2F%3EThis%20means%20that%20all%20the%20headers%20would%20not%20be%20in%20the%20same%20row%20but%20in%20the%20same%20column.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811046%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Table%20using%20lines%20as%20separators%20and%20not%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394580%22%20target%3D%22_blank%22%3E%40DonutsSauvage%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20want%20is%20not%20considered%20a%20table.%3C%2FP%3E%3CP%3EA%20table%20has%20headers%20in%20the%20first%20row%2C%20data%20in%20subsequent%20rows%2C%20no%20empty%20rows.%3C%2FP%3E%3CP%3EA%20lot%20of%20functions%20require%20this%20structure%20(SUMIF()%2C%20Advanced%20Filter%2C%20DBMIN()%2C%20...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Pretty simple question but I didn't find any answer to this:

My goal is Simply to create a Table in Excel like anyone would do using the "create table" option, but instead of having "Column1", "Column2"... as fields for the table, I want to have "Line1", "Line2"...
I already tried copy-pasting a table with the transpose option but Excel does not consider the result to be a table anymore. I work under Excel 365.
Edit: To clarify, the goal is not to name the headers! I want to have a Table using ROWS as separators instead of COLUMNS.
e.g:
Header1 | Value 1 | Value2...
Header2 | Value 1 | Value2...
Header3 | Value 1 | Value2...

5 Replies

@Deleted 

You may enter Line1, drag it to the right till LineN and Ctrl+T on selection with check first row as header

I clarified the question because I think there was a misunderstanding

@Deleted 

Sorry, I didn't catch. You have some range and would like to use values from first column as column names, or you'd like to rotate entire range to the right on 90, or what. Perhaps you may give small sample how it shall be transferred.

I'll try to be as precise as possible. The goal is to have a Table in Excel, for which the headers and corresponding values would not be in the same column, but the same row.
This means that all the headers would not be in the same row but in the same column.
Solution

@Deleted 

What you want is not considered a table.

A table has headers in the first row, data in subsequent rows, no empty rows.

A lot of functions require this structure (SUMIF(), Advanced Filter, DBMIN(), ...)

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies