It will be helpful if you attach / post a workable document.

In the meantime here is an example that can help you.

SET NOCOUNT ON;

USE tempdb;

GO

DECLARE @x xml = '

<Table xmlns:ss="uri">

<Row ss:StyleID="s63" ID="1">

<Cell><Data ss:Type="String">xxxxxxxxx-1</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-2</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-3</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxxx-4</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-5</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxx-6</Data></Cell>

<Cell><Data ss:Type="String">xxxxxx-7</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxx-8</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-9</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-10</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxxxx-11</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxxxx-12</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-13</Data></Cell>

</Row>

<Row ss:StyleID="s63" ID="2">

<Cell><Data ss:Type="String">xxxxxxxx-1</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-2</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-3</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-4</Data></Cell>

<Cell><Data ss:Type="String">xxxxxxxx-5</Data></Cell>

</Row>

</Table>';

WITH XMLNAMESPACES ('uri' AS ss)

,C1 AS (

SELECT

n1.r.value('@ID[1]', 'int') AS RID,

n2.d.value('text()[1]', 'varchar(128)') AS val,

ROW_NUMBER() OVER(PARTITION BY n1.r ORDER BY n2.d) AS rn

FROM

@x.nodes('Table/Row') AS n1(r)

CROSS APPLY

n1.r.nodes('Cell/Data') AS n2(d)

)

SELECT

RID,

val

FROM

C1

WHERE

rn < 5

ORDER BY

RID,

rn;

GO