Next solution avoids creating a new sections, which makes it more difficult to change headers, footers, margins, etc. in a consistent manner.
- Insert a Drawing Canvas (Menu, Insert, Illustration, Shapes, New Drawing Canvas at the bottom of the menu).
- Insert a Text Box inside the canvas (Menu, Insert, Illustration, Shapes, Basic Shapes, first element: Text Box).
- Copy the table and the text you want to rotate and paste it inside the textbox, or directly create them inside the Text Box.
- Select and rotate the Text Box.
In the text flow, a Drawing Canvas works like a figure when either is inserted in a paragraph. You can center the paragraph, add space before or after the paragraph, etc.
If the table does not fit the page, you can decrease the font. You can also play with the margins of the cells of the table.
Of course, you could make a table in Excel and copy it in Word as a figure, and rotate it, but the previous solution has a better resolution to file weight ratio.