regarding the data formatting

[Muneer111]

Hi @GuangchuangYu
I trust you are find and doing good.
I am new to microbiome and R,
I have a dataset and i am trying to analyze it.
But I don't know how to format my dataset. kindly please let me know or provide a rough data so that i can get an idea how to format the data.
Note i have got my data in excel file with OTUs in one column and the taxonomy upto species level in other columns.
Now Question 1
Do, I need to combined all the taxonomic levels into a single excel sheet.
Question 2:
How to arrange the dataset
Kindly suggest
thanks and Regards

class.xlsx
Phyllum.xlsx

[Muneer111]

Hi @GuangchuangYu
Are you there
please help out if possible
Thanking You